package com.api.browser.service.impl;

import org.apache.log4j.Logger;
import weaver.conn.RecordSet;
import weaver.general.Util;
import weaver.hrm.User;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class E8DataQuery {
    Logger log = Logger.getLogger(Logger.class);
    public List<Map<String, String>> getScheduleList(User paramUser, Map<String, String> paramMap, HttpServletRequest paramHttpServletRequest, HttpServletResponse paramHttpServletResponse) {

        return null;
    }
    public List<Map<String, String>> getScheduleList(User paramUser, HttpServletRequest paramHttpServletRequest, HttpServletResponse paramHttpServletResponse) {
        List<Map<String,String>> list=new ArrayList<Map<String,String>>();
        RecordSet re=new RecordSet();
        String sql="select id requestid,fieldname requestname,fielddbtype creater,type createtimes  from  workflow_billfield a";
        log.error("getScheduleList"+sql);
        re.execute(sql);
        Map<String,String> map=null;
        while(re.next()){
            map=new HashMap<String,String>();
            String requestid= re.getString("requestid");
            String requestname= re.getString("requestname");
            String creater= re.getString("creater");
            String createtimes= re.getString("createtimes");
            map.put("requestid",requestid);
            map.put("requestname",requestname);
            map.put("creater",creater);
            map.put("createtimes",createtimes);
            list.add(map);
        }

        return list;
    }
}
